<?php

$foo=$_GET["projectid"];

include("mysql_conn.php");
include("settings.php");

$result=mysql_query("select p.projectid,p.title,s.state_desc from projects p, states s where p.state=s.state and projectid='$foo'");
$data=mysql_fetch_array($result);

echo "<html><head><title>$site_title: Change Project State</title><link rel='stylesheet' type='text/css' href='style.css'></head><body>
<h3>Change Project State:"; 
print $data['title']; 
echo "</h3><br> Current State:"; 
print $data['state_desc'];
echo "<br>
Change to: <form action='changestate-do.php' method='post'>
<input type='radio' name='state' value='1'> Ready<br>
<input type='radio' name='state' value='2'> Not Ready<br>
<input type='radio' name='state' value='3'> Old<br>
<input type='hidden' name='projectid' value='$foo'>
<input type='submit' value='Change'>
</body></html>";

?>
